
-- MySQL dump 10.13  Distrib 5.7.19, for macos10.12 (x86_64)
--
-- Host: 127.0.0.1    Database: Hotel
-- ------------------------------------------------------
-- Server version	5.7.19-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `Coupon`
--

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `Coupon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Coupon` (
                          `id` int(11) NOT NULL AUTO_INCREMENT,
                          `description` varchar(255) DEFAULT NULL,
                          `hotelId` int(11) DEFAULT '-1',
                          `couponType` int(11) NOT NULL,
                          `couponName` varchar(255) NOT NULL,
                          `target_money` double DEFAULT NULL,
                          `multi_threshold` int(11) DEFAULT NULL,
                          `discount` double DEFAULT NULL,
                          `status` int(11) DEFAULT NULL,
                          `start_time` datetime DEFAULT NULL,
                          `end_time` datetime DEFAULT NULL,
                          `discount_money` double DEFAULT NULL,
                          PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Coupon`
--
BEGIN;
/*!40000 ALTER TABLE `Coupon` DISABLE KEYS */;
INSERT INTO `Coupon` VALUES (1,'满500-100优惠',2,2,'满减优惠券',500,NULL,0,1,NULL,NULL,100);
INSERT INTO `Coupon` VALUES (2,'国庆优惠',1,1,'节日优惠券',NULL,NULL,0.8,1,'2021-10-01','2021-10-07',NULL);
INSERT INTO `Coupon` VALUES (3,'3间优惠',1,0,'多间优惠券',NULL,3,0.9,1,NULL,NULL,NULL);
INSERT INTO `Coupon` VALUES (4,'网站优惠',0,2,'网站满减优惠券200-5',200,NULL,0,1,NULL,NULL,5);
/*!40000 ALTER TABLE `Coupon` ENABLE KEYS */;
COMMIT;

--
-- Table structure for table `Hotel`
--

DROP TABLE IF EXISTS `Hotel`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Hotel` (/*创建了Hotel这个表，存储对应信息*/
                         `id` int(11) NOT NULL AUTO_INCREMENT,
                         `hotelName` varchar(255) NOT NULL,
                         `hotelDescription` varchar(255) DEFAULT NULL,
                         `address` varchar(255) DEFAULT NULL,
                         `bizRegion` varchar(255) DEFAULT NULL,
                         `hotelStar` varchar(255) DEFAULT NULL,
                         `phoneNum` varchar(255) DEFAULT NULL,
                         `rate` double(255,1) DEFAULT NULL,
                         `manager_id` int(11) DEFAULT NULL,
                         `picture` varchar(255) DEFAULT 'https://software-engineering.oss-cn-beijing.aliyuncs.com/hotel_default.jpeg',
                         PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Hotel`
--

BEGIN;
/*!40000 ALTER TABLE `Hotel` DISABLE KEYS */;
INSERT INTO `Hotel` VALUES (1,'皇冠假日酒店','宜昌富力皇冠假日酒店地处沿江大道，毗邻集商业、购物、娱乐为一体的万达广场，俯瞰长江，山色江景一览无遗。地理位置优越，交通便利，距离宜昌火车站仅2.5公里；驱车35分钟即可到达三峡机场；世界闻名遐迩的三峡大坝，葛洲坝及清江画廊风景区亦近在咫尺。','湖北省宜昌市伍家岗区沿江大道169号','湖北省 宜昌市 伍家岗区','Five','1829373819',4.5,6,'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fimg-md.veimg.cn%2Fmeadincms%2Fimg3%2Finfo%2Fzhaocuiyan%2F201210%2F121020tu5.jpg&refer=http%3A%2F%2Fimg-md.veimg.cn&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1641738209&t=516dd69c95d84737a38f96d615205762');
INSERT INTO `Hotel` VALUES (2,'如家酒店','如家酒店地处宜昌市商业中心地段，毗邻夷陵广场、CBD购物中心及儿童公园。酒店一楼广场有停车场，门前即有BRT快速公交车站，位于酒店一楼的客运站有直达三峡机场、火车东站、各旅游景区及周边县市的大巴车，出行极为方便快捷。周边餐饮、娱乐业众多，是您出差、旅游、休闲的理想居停之所。','宜昌市西陵区东山大道126号长途汽车站2-4F','湖北省 宜昌市 西陵区','Three','1829373819',3.9,6,'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fhimg1.qunarzz.com%2Fimgs%2F201907%2F06%2FC.D9RoiSvQZ6-tuQl0g480s.jpg&refer=http%3A%2F%2Fhimg1.qunarzz.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1641884009&t=b4f92bbefd552056650251e5d997841a');
INSERT INTO `Hotel` VALUES (3,'宜昌国际大酒店','宜昌国际大酒店位于宜昌市沿江大道与胜利四路交汇处的黄金地段，南依美丽的长江之滨，西临商贾云集的繁华闹市，是一家四星级酒店，交通便利，环境幽雅。欢迎您入住','宜昌市伍家岗区沿江大道121号','湖北省 宜昌市 伍家岗区','Four','1812443710',5.0,6,'https://tse1-mm.cn.bing.net/th/id/R-C.97f0bbcaff02890da91aad06c4fe82dd?rik=Pa9QewfYWi9%2boQ&riu=http%3a%2f%2fphotosanxia.com%2fUploadFile%2f2006329135436989.jpg&ehk=%2fBnTVzV4Kn5tUErwsHxo2NWTGv%2buLf1FTmoYtGG0fs8%3d&risl=&pid=ImgRaw&r=0');
INSERT INTO `Hotel` VALUES (4,'运7酒店','酒店定位于视、味、感三味一体的全新升级品牌，客房风格轻爽活跃、卫浴设施人性舒适、服务个性温馨，坚持使用高品质的床上用品为客户提供高质量的睡眠体验，坚持用真诚的微笑和贴心的服务为客户提供宾至如归的住宿体验。','宜昌市伍家岗区胜利一路','湖北省 宜昌市 伍家岗区','Three','1829373819',4.5,9,'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fdimg04.c-ctrip.com%2Fimages%2F0200e120008o7krdl509B_R_300_225_R5_Q70_D.jpg&refer=http%3A%2F%2Fdimg04.c-ctrip.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1641738306&t=a7346a11e55f09f60086f9bc0e6e9aa2');
INSERT INTO `Hotel` VALUES (5,'民生酒店','酒店至汉宜高速公路入口约5分钟车程，是宜昌周边一日游的必经之地；约20分钟车程可至宜昌火车东站，出行十分便利。酒店楼高26层，拥有风格典雅的各类客房，装饰经典高雅、宽敞舒适。酒店一贯坚持“把客人当亲友”的服务理念，力求为你提供“家外之家”的温馨与便捷。','宜昌市西陵区发展大道21号','湖北省 宜昌市 西陵区','Three','1829373819',4.4,8,'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fdimg11.c-ctrip.com%2Fimages%2F200q0n000000eja71F248_R_170_170.jpg&refer=http%3A%2F%2Fdimg11.c-ctrip.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1641814184&t=0e00ab5f6c3fb2a1f039ef35eb135436');
INSERT INTO `Hotel` VALUES (6,'丽橙酒店','这是夷陵区第一家以时尚为主题的经济型连锁酒店。酒店邀请国内知名设计倾情打造，清新典雅之余又不失现代时尚的气息与功能。酒店的全部客房均数码电视、市话、24小时热水等配套设施。安逸的环境，让您尽享“丽”之优雅、“橙”之恬静。同时秉承“时尚炫丽、成功人生”的宗旨，为大众提供时尚、超值、温馨的服务，让你体验胜似居家的完美享受。','宜昌市夷陵区罗河路2号','湖北省 宜昌市 夷陵区','Four','1829373819',4.7,9,'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Faff.bstatic.com%2Fimages%2Fhotel%2F840x460%2F511%2F51109507.jpg&refer=http%3A%2F%2Faff.bstatic.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1641814316&t=b34b2ae8529a85b832cb4049dce5b87e');
INSERT INTO `Hotel` VALUES (7,'恒大酒店','湖北宜昌恒大酒店地处中国优秀旅游城市宜昌，坐落于风景秀丽的夷陵区（高新区）核心商务区，毗邻宜昌恒大绿洲，浓郁的欧陆风情建筑结合纯正的皇家园林，低调而惊艳。是一家集客房、餐饮、会议、康体、运动、娱乐于一体的商务会议、休闲度假酒店。恒大酒店集团将开创宜昌商旅与休闲度假市场卓越服务的新篇章。','宜昌市夷陵区发展大道117号','湖北省 宜昌市 夷陵区','Five','1829373819',4.9,7,'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fhotel.evergrande.com%2Fuploads%2Fimage%2F202101%2F21%2F60092eea98064.jpg&refer=http%3A%2F%2Fhotel.evergrande.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1641814617&t=0e1ae799059ae6b6a3309d84573c3719');
INSERT INTO `Hotel` VALUES (8,'东方国际大酒店','酒店选址于当阳市环城南路，北侧紧靠玉泉河道，周边交通便利、环境优越。酒店将融古典欧式风格和现代设计风格为一体，内部布局合理，功能齐全，设置有240多间（套）客房、有可容纳2000人同时进餐的餐厅、多个会议室及洽谈室，为宾客多元化及灵活性的会议、宴会需求提供最大的选择空间。配套建成的商业风情街，高档舒适的休闲消费环境，将引领当阳新的消费理念。','宜昌市当阳市环城南路79号','湖北省 宜昌市 当阳市','Four','1829373819',4.4,7,'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fdimg04.c-ctrip.com%2Fimages%2F20040400000000lnj565C_R_1080_540.jpg&refer=http%3A%2F%2Fdimg04.c-ctrip.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1641884408&t=03ab729629b2741b5a0a7fb497825d91');
INSERT INTO `Hotel` VALUES (9,'华美达宜昌大酒店','华美达宜昌大酒店地处宜昌市中心，紧邻城市绿肺儿童公园，距宜昌火车站仅3分钟车程，距三峡游轮码头20分钟，三峡国际机场40分钟车程，交通便利。 酒店客房设计高贵典雅，配备完善的现代化设备。酒店另配备无烟楼层、连通客房以及行动不便人士专用客房，同时还拥有宜昌市独有的酒店公寓套房，配有开放式厨房、全套家电设施，是商旅客人长驻的最佳选择。','宜昌西陵区云集路27号','湖北省 宜昌市 西陵区','Five','1829373819',4.9,8,'https://img0.baidu.com/it/u=992209205,2459227972&fm=26&fmt=auto');
INSERT INTO `Hotel` VALUES (10,'宜昌虹桥国际大酒店','酒店装修豪华典雅，是一家新中式风格的星级酒店，主要经营客房、餐饮、宴会、会议服务。配备多样化的客房，个性化的宴会厅可同时容纳1500人用餐，设有豪华包房、多媒体会议室等。虹桥人以最真诚、热情、尽善尽美的服务为八方宾客提供高贵的享受，虹桥国际大酒店邀请您共同见证我们的成长。','宜昌市伍家岗区夷陵大道358号','湖北省 宜昌市 伍家岗区','Four','1829373819',4.5,9,'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fpavo.elongstatic.com%2Fi%2Fmobile960%2Fnw_Kn9pd4yxOg.jpg&refer=http%3A%2F%2Fpavo.elongstatic.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1641816785&t=3cf81893661b4d2cb87fdb1d11e89194');
INSERT INTO `Hotel` VALUES (11,'均瑶禧玥酒店','宜昌均瑶禧玥酒店独踞于国贸商圈核心地段，面临夷陵休闲广场，毗邻CBD、大洋百货、宜昌火车站，距离三峡国际机场约40分钟车程，以其优越的地理优势成为商旅客人的钟爱之选。酒店拥有舒适、宽敞的客房，房间设计时尚大方，设施。酒店特为商务人士准备有多功能会议室、宴会厅，提供全方位服务。相信这里将是你工作、休憩的上佳之选。','宜昌市西陵区西陵一路51号宜昌均瑶大厦','湖北省 宜昌市 西陵区','Four','1829373819',4.8,9,'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fwww.redtourism.com.cn%2Ftris%2FnewImgTem%2Fc658c803d70d430483ab449893c8be40.jpg&refer=http%3A%2F%2Fwww.redtourism.com.cn&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1641884138&t=99a01042b1d96178798e322200fab48f');
INSERT INTO `Hotel` VALUES (12,'维也纳酒店','酒店位于发展大道，毗邻夷陵万达广场，拥有各类房型客房一百余间，配套1000余个餐位的特色餐饮，大型宴会厅、高档的自助餐厅、先进的商务中心、大型停车场，设施豪华、功能齐备、热情周到的服务，是您会议、旅游、商务出行的上佳选择，将成为宜昌夷陵区的酒店行业新标杆！','宜昌市夷陵区发展大道18号','湖北省 宜昌市 夷陵区','Four','1829373819',4.7,6,'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fak-d.tripcdn.com%2Fimages%2F200j0y000000lq0rnD9C0_R_600_400_R5_D.jpg&refer=http%3A%2F%2Fak-d.tripcdn.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1641817377&t=2c9d1ea03703d2285ff0af142a11ffa6');
INSERT INTO `Hotel` VALUES (13,'盈嘉酒店','宜昌盈嘉酒店位于享有世界水电之都、三峡明珠之称的美丽的宜昌市，地处市中心商务区的黄金地段，毗邻风景秀丽的儿童公园、夷陵广场，距三峡机场30分钟车程，距宜昌火车站、长途客运站5分钟车程，地理位置优越，交通极为便利，是商旅客人下榻的理想之地。','宜昌市珍珠路69号','湖北省 宜昌市 西陵区','Three','1829373819',3.5,5,'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fp1.meituan.net%2Ftdchotel%2Fa5ae3c2fbd9a29d87654ec111b95e4c068076.jpg&refer=http%3A%2F%2Fp1.meituan.net&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1641817583&t=c080bacc0b331c17f491f41d2edc8492');
INSERT INTO `Hotel` VALUES (14,'沐兰酒店','宜昌沐兰酒店位于东山开发区汕头路，临近大老岭国家公园，环境舒适，出游便利。宜昌沐兰酒店装修简约大气，客房舒适干净。酒店提供行李寄存、24小时前台服务，停车场等，配设齐全，热情周到的服务让每位客人享受放松和舒适，犹如在家一样安心自在。','宜昌市西陵区东山开发区汕头路16号','湖北省 宜昌市 西陵区','Three','1829373819',3.7,6,'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fpavo.elongstatic.com%2Fi%2FHotel870_470%2Fnw_000d4ObX.jpg&refer=http%3A%2F%2Fpavo.elongstatic.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg?sec=1641817963&t=92f8e6c7999103921abd39c4d1e1588e');
COMMIT;

--
-- Table structure for table `OrderList`
--

DROP TABLE IF EXISTS `OrderList`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `OrderList` (
                             `id` int(11) NOT NULL AUTO_INCREMENT,
                             `userId` int(11) DEFAULT NULL,
                             `hotelId` int(11) DEFAULT NULL,
                             `hotelName` varchar(255) DEFAULT NULL,
                             `checkInDate` varchar(255) DEFAULT NULL,
                             `checkOutDate` varchar(255) DEFAULT NULL,
                             `roomType` varchar(255) DEFAULT NULL,
                             `roomNum` int(255) DEFAULT NULL,
                             `peopleNum` int(255) DEFAULT NULL,
                             `haveChild` tinytext,
                             `createDate` varchar(255) DEFAULT NULL,
                             `price` decimal(65,0) DEFAULT NULL,
                             `clientName` varchar(255) DEFAULT NULL,
                             `phoneNumber` varchar(255) DEFAULT NULL,
                             `orderState` varchar(255) DEFAULT NULL,
                             PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `OrderList`
--

/*!40000 ALTER TABLE `OrderList` DISABLE KEYS */;
/*!40000 ALTER TABLE `OrderList` ENABLE KEYS */;

--
-- Table structure for table `Comment`
--

DROP TABLE IF EXISTS `Comment`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Comment`(
                          `id` int(11) NOT NULL AUTO_INCREMENT,
                          `create_time` datetime DEFAULT NULL,
                          `hotel_id` int(11) DEFAULT NULL,
                          `order_id` int(11) DEFAULT NULL,
                          `user_name` varchar(255) DEFAULT NULL,
                          `grade` int(11) DEFAULT NULL,
                          `content` varchar(255) DEFAULT NULL,
                          PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Comment`
--

BEGIN;
/*!40000 ALTER TABLE `Comment` DISABLE KEYS */;
INSERT INTO `Comment` VALUES(1,'2021-12-02 19:01:45',1,2,'汪婵',3,'就那样，肯定没家里舒服');/*插入评价*/
INSERT INTO `Comment` VALUES(2,'2021-12-01 16:01:45',1,3,'陈洋',4,'还阔以，只是没欣苑3栋613舒服');
INSERT INTO `Comment` VALUES(3,'2021-12-02 19:01:45',1,4,'鲍洋',5,'YYDS');
INSERT INTO `Comment` VALUES(4,'2021-12-03 19:01:45',2,5,'程杨',1,'Dnmd，退钱！晚上吵死！');
INSERT INTO `Comment` VALUES(5,'2021-12-02 19:01:45',2,6,'徐文卓',2,'那是真的牛逼');
/*!40000 ALTER TABLE `Comment` ENABLE KEYS */;
COMMIT;

--
-- Table structure for table `Room`
--

DROP TABLE IF EXISTS `Room`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Room` (
                        `id` int(11) NOT NULL AUTO_INCREMENT,
                        `price` double DEFAULT NULL,
                        `total` int(11) DEFAULT NULL,
                        `hotel_id` int(11) DEFAULT NULL,
                        `roomType` varchar(50) DEFAULT NULL,
                        PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Room`
--

BEGIN;
/*!40000 ALTER TABLE `Room` DISABLE KEYS */;/*添加不同酒店房间的价格的类型*/
INSERT INTO `Room` VALUES (2,199,20,1,'BigBed'),(3,299,30,1,'DoubleBed'),(4,399,10,1,'Family');
INSERT INTO `Room` VALUES (5,199,20,2,'BigBed'),(6,299,30,2,'DoubleBed'),(7,399,10,2,'Family');
INSERT INTO `Room` VALUES (8,199,20,3,'BigBed'),(9,289,30,3,'DoubleBed'),(10,399,10,3,'Family');
INSERT INTO `Room` VALUES (11,199,20,4,'BigBed'),(12,299,30,4,'DoubleBed'),(13,399,10,4,'Family');
INSERT INTO `Room` VALUES (14,199,20,5,'BigBed'),(15,269,30,5,'DoubleBed'),(16,399,10,5,'Family');
INSERT INTO `Room` VALUES (17,199,20,6,'BigBed'),(18,219,30,6,'DoubleBed'),(19,399,10,6,'Family');
INSERT INTO `Room` VALUES (20,299,20,7,'BigBed'),(21,399,30,7,'DoubleBed'),(22,499,10,7,'Family');
INSERT INTO `Room` VALUES (23,199,20,8,'BigBed'),(24,279,30,8,'DoubleBed'),(25,399,10,8,'Family');
INSERT INTO `Room` VALUES (26,199,20,10,'BigBed'),(27,229,30,9,'DoubleBed'),(28,399,10,9,'Family');
INSERT INTO `Room` VALUES (29,199,20,11,'BigBed'),(30,239,30,11,'DoubleBed'),(31,399,10,11,'Family');
INSERT INTO `Room` VALUES (32,199,20,12,'BigBed'),(33,299,30,12,'DoubleBed'),(34,399,10,12,'Family');
INSERT INTO `Room` VALUES (35,159,20,13,'BigBed'),(36,219,30,13,'DoubleBed'),(37,399,10,13,'Family');
INSERT INTO `Room` VALUES (38,199,20,14,'BigBed'),(39,299,30,14,'DoubleBed'),(40,399,10,14,'Family');
/*!40000 ALTER TABLE `Room` ENABLE KEYS */;
COMMIT;

--
-- Table structure for table `User`
--

DROP TABLE IF EXISTS `User`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `User` (
                        `id` int(11) NOT NULL AUTO_INCREMENT,
                        `email` varchar(255) DEFAULT NULL unique ,
                        `password` varchar(32) NOT NULL,
                        `username` varchar(255) DEFAULT NULL,
                        `phonenumber` varchar(255) DEFAULT NULL,
                        `credit` double(255,0) DEFAULT NULL,
                        `usertype` varchar(255) DEFAULT NULL,
                        `avatar` varchar(255) DEFAULT 'https://zos.alipayobjects.com/rmsportal/ODTLcjxAfvqbxHnVXCYX.png',
                        PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `User`
--

BEGIN;
/*!40000 ALTER TABLE `User` DISABLE KEYS */;
INSERT INTO `User` VALUES (4,'111@qq.com','e10adc3949ba59abbe56e057f20f883e','客户1','12345678919',100,'Client','https://zos.alipayobjects.com/rmsportal/ODTLcjxAfvqbxHnVXCYX.png');
INSERT INTO `User` VALUES (5,'123@qq.com','e10adc3949ba59abbe56e057f20f883e','客户2','12345678911',100,'Client','https://zos.alipayobjects.com/rmsportal/ODTLcjxAfvqbxHnVXCYX.png');
INSERT INTO `User` VALUES (6,'333@qq.com','e10adc3949ba59abbe56e057f20f883e','酒店职工1','13159175930',100,'HotelManager','https://zos.alipayobjects.com/rmsportal/ODTLcjxAfvqbxHnVXCYX.png');
INSERT INTO `User` VALUES (7,'222@qq.com','e10adc3949ba59abbe56e057f20f883e','管理员','12345678919',100,'Admin','https://zos.alipayobjects.com/rmsportal/ODTLcjxAfvqbxHnVXCYX.png');
INSERT INTO `User` VALUES (8,'444@qq.com','e10adc3949ba59abbe56e057f20f883e','网站工作人员1号','12345678911',100,'Manager','https://zos.alipayobjects.com/rmsportal/ODTLcjxAfvqbxHnVXCYX.png');
INSERT INTO `User` VALUES (9,'chuan@qq.com','e10adc3949ba59abbe56e057f20f883e','酒店职工2','12345678919',100,'HotelManager','https://zos.alipayobjects.com/rmsportal/ODTLcjxAfvqbxHnVXCYX.png');
/*!40000 ALTER TABLE `User` ENABLE KEYS */;
COMMIT;

--
-- Table structure for table `Credit`
--

DROP TABLE IF EXISTS `Credit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Credit`(
                         `id` int(11) NOT NULL AUTO_INCREMENT,
                         `user_id` int(11) DEFAULT NULL,
                         `action` varchar(255) DEFAULT NULL,
                         `time` datetime DEFAULT NULL,
                         `order_id` int(11) DEFAULT NULL,
                         `sign` varchar(255) DEFAULT NULL,
                         `change_num` double(255,0) DEFAULT NULL,
                         `result` double(255,0) DEFAULT NULL,
                         PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Content`
--

BEGIN;
/*!40000 ALTER TABLE `Credit` DISABLE KEYS */;
INSERT INTO `Credit` VALUES(1,4,'INIT','2021-04-15',NULL,NULL,NULL,100);
INSERT INTO `Credit` VALUES(2,4,'EXECUTE','2021-05-15',1,'ADD',20,120);
INSERT INTO `Credit` VALUES(3,5,'INIT','2021-06-04',NULL,NULL,NULL,100);
/*!40000 ALTER TABLE `Credit` ENABLE KEYS */;
COMMIT;


/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

SET FOREIGN_KEY_CHECKS = 1;
